﻿CREATE TABLE [dbo].[Movie] (
    [Id]           INT             IDENTITY (1, 1) NOT NULL,
    [CategoryId]   INT             NOT NULL,
    [RatingId]     INT             NOT NULL,
    [Title]        NVARCHAR (256)  COLLATE Latin1_General_CI_AS NOT NULL,
    [ImdbId]       NVARCHAR (50)   COLLATE Latin1_General_CI_AS NULL,
    [ImdbUrl]      NVARCHAR (256)  COLLATE Latin1_General_CI_AS NULL,
    [PictureUrl]   NVARCHAR (256)  COLLATE Latin1_General_CI_AS NULL,
    [ReleaseDate]  DATETIME        NULL,
    [FollowUpDate] DATETIME        NULL,
    [UserRating]   DECIMAL (2, 1)  NULL,
    [Director]     NVARCHAR (256)  COLLATE Latin1_General_CI_AS NULL,
    [Casts]        NVARCHAR (1000) COLLATE Latin1_General_CI_AS NULL,
    [Plot]         NVARCHAR (1000) COLLATE Latin1_General_CI_AS NULL,
    [Comment]      NVARCHAR (1000) COLLATE Latin1_General_CI_AS NULL,
    [Downloaded]   BIT             NOT NULL,
    [Watched]      BIT             NOT NULL,
    [StorageUrl]   NVARCHAR (400)  COLLATE Latin1_General_CI_AS NULL
);

